
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspFAQItem_INSERT
(
@question AS nvarchar(4000) = null,
@answer AS nvarchar(4000) = null,
@orderNumber AS int = null,
@isDeleted AS bit = null,
@createDate AS datetime = null,
@lastModifiedDate AS datetime = null
)
AS

INSERT INTO
  [dbo].[FAQItem]
(
  [Question],
  [Answer],
  [OrderNumber],
  [IsDeleted],
  [CreateDate],
  [LastModifiedDate]
)
VALUES
(
  @question,
  @answer,
  @orderNumber,
  @isDeleted,
  @createDate,
  @lastModifiedDate
)

SELECT SCOPE_IDENTITY()

GO
